class CreateUsers < ActiveRecord::Migration
  def self.up
    execute "CREATE TABLE users (id int(11) NOT NULL auto_increment,
                                 login varchar(255) default NULL,
                                 email varchar(255) default NULL,
                                 crypted_password VARCHAR(40) default NULL,
                                 salt VARCHAR(40) default NULL,
                                 firstName varchar(255) default NULL,
                                 name varchar(255) default NULL,
                                 status enum('admin','user') DEFAULT 'user' NOT NULL,
                                 created_at TIMESTAMP,
                                 update_at TIMESTAMP,
                                 remember_token varchar(255) default NULL,
                                 remember_token_expires_at TIMESTAMP,
                                 PRIMARY KEY  (id))"
  end

  def self.down
    execute "DROP TABLE users"
  end
end
